Search results 59

  2. Search results
  3. sql statement
Card image cap
Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

Mar4
Card image cap
DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

Mar3
Card image cap
UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

Feb18
Card image cap
Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

Feb8
Card image cap
SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

Feb3
Card image cap
Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

Jan30
Card image cap
SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Jan20
Card image cap
ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

Jan17
Card image cap
ANmaHTMLPadding

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Jan5
Card image cap
SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29
Card image cap
Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2
Card image cap
SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3